﻿CREATE VIEW [dbo].[vVideos]
	AS 
	
	SELECT	v.*,
			vf.FilePath,
			vf.OriginalFileName,
			vf.CurrentFileName,
			vf.DateAdded,
			vf.VideoLength,
			vf.AudioLength,
			vf.FileSize,
			vf.VideoWidth,
			vf.VideoHeight,
			vf.AudioSubType,
			vf.VideoSubType,
			vf.AudioBitRate,
			vf.VideoBitRate,
			vf.FourCC,
			vf.FrameRate,
			vf.FileType,
			vf.IsVBR,
			vf.IsDeleted,
			vf.IsPrivate,
			vf.IsReplacement,
			vf.MediaClassID
	FROM	[dbo].[Video] v LEFT OUTER JOIN
			[dbo].[VideoFile] vf ON v.VideoFileID = vf.VideoFileID